package com.project.isaacwiki.mapper;

import com.project.isaacwiki.dto.ItemMvp;
import com.project.isaacwiki.pojo.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface MapperQueryItem {
    List<ItemMvp> queryAllItemMvp();

    @Select("select * from items where id = #{id}")
    Item queryItemById(int id);

    @Select("select * from items_attributes where id = #{id}")
    ItemsAttributes queryItemAttributesById(int id);

    @Select("select * from synergy where item_a_id = #{id}")
    List<Synergy> querySynergyById(int id);

    List<ItemPoolType> queryItemPoolTypeById(int id);

    @Select("select * from item_img_path where item_id = #{id}")
    ItemImgPath queryItemImgPathById(int id);

    List <ItemMvp> queryItemMvpByName(String name);
}
